2014-06-13 - 13251 - Rel Notes - Create odbcad32 connection #BIReleases2014
Release Notes
13251 - Create odbcad32 connection
Admin Info
Purpose
|
Create odbcad32 connection
|
Release No
|
001
|
Submitted
|
06-13-2014
|
Submitted by
|
Praveen Guntuka
|
Source/Destination Systems
|
IT->BMS->QA folder to IT->BMS->Prod folder
|
Release Sent To
|
Saravanan Lakshmanan
|
Object(s) Created By
|
Praveen Guntuka
|
Object(s) Tested By
|
Praveen Guntuka
|
Release Notes
For Infrastructure
None
For Requestor
1. Need to change the datatype to Number for UPC values in the Sheet.
2. Need to save the CSV file to MS Workbook(.xlsx) format.
3. Need to create ODBC 32 bit driver for Excel sheet.
4. Need to use the ODBC 32 bit driver in the report to access MS Workbook.
5. Need to link the Sheet UPC numbers to EAN11 field in MEAN table.
Test Notes
SNo.
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
As per NEC standard checklist.
|
2
|
Executed Crystal Report in Crystal Designer tool after changes.
|
Report executed successfully in Crystal Designer tool.
|
3
|
Scheduled the Report in NEC BI Launch Pad.
|
Report executed successfully in NEC BI Launch Pad.
|
Reference Document(Specification)
2014-06-13 - 13251 - Enhancement - Create odbcad32 connection